Dataset statistics
| Number of variables | 25 |
|---|---|
| Number of observations | 37709 |
| Missing cells | 334573 |
| Missing cells (%) | 35.5% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 28.6 MiB |
| Average record size in memory | 795.9 B |
Variable types
| Categorical | 10 |
|---|---|
| Numeric | 12 |
| Unsupported | 3 |
ClaseVehiculo__c has constant value "99999" | Constant |
TipoVehiculo__c has constant value "99999" | Constant |
n_prod_prev is highly correlated with total_siniestros and 2 other fields | High correlation |
total_siniestros is highly correlated with n_prod_prev and 2 other fields | High correlation |
total_pagado_smmlv is highly correlated with n_prod_prev and 3 other fields | High correlation |
anios_ultimo_siniestro is highly correlated with n_prod_prev and 2 other fields | High correlation |
Activos__c is highly correlated with AnnualRevenue | High correlation |
AnnualRevenue is highly correlated with Activos__c and 1 other fields | High correlation |
MontoAnual__c is highly correlated with total_pagado_smmlv | High correlation |
EgresosAnuales__c is highly correlated with AnnualRevenue | High correlation |
total_siniestros is highly correlated with total_pagado_smmlv and 1 other fields | High correlation |
total_pagado_smmlv is highly correlated with total_siniestros and 1 other fields | High correlation |
anios_ultimo_siniestro is highly correlated with total_siniestros and 1 other fields | High correlation |
AnnualRevenue is highly correlated with EgresosAnuales__c | High correlation |
EgresosAnuales__c is highly correlated with AnnualRevenue | High correlation |
n_prod_prev is highly correlated with total_siniestros | High correlation |
total_siniestros is highly correlated with n_prod_prev and 2 other fields | High correlation |
total_pagado_smmlv is highly correlated with total_siniestros and 2 other fields | High correlation |
anios_ultimo_siniestro is highly correlated with total_siniestros and 1 other fields | High correlation |
AnnualRevenue is highly correlated with EgresosAnuales__c | High correlation |
MontoAnual__c is highly correlated with total_pagado_smmlv | High correlation |
EgresosAnuales__c is highly correlated with AnnualRevenue | High correlation |
churn is highly correlated with TipoVehiculo__c and 2 other fields | High correlation |
TipoVehiculo__c is highly correlated with churn and 8 other fields | High correlation |
Genero__pc is highly correlated with TipoVehiculo__c and 3 other fields | High correlation |
ClaseVehiculo__c is highly correlated with churn and 8 other fields | High correlation |
FechaInicioVigencia__ctrim is highly correlated with churn and 2 other fields | High correlation |
tipo_prod_desc is highly correlated with TipoVehiculo__c and 2 other fields | High correlation |
tipo_ramo_name is highly correlated with TipoVehiculo__c and 2 other fields | High correlation |
EstadoCivil__pc is highly correlated with TipoVehiculo__c and 3 other fields | High correlation |
ciudad_name is highly correlated with TipoVehiculo__c and 2 other fields | High correlation |
CodigoTipoAsegurado__c is highly correlated with TipoVehiculo__c and 4 other fields | High correlation |
PuntoVenta__c is highly correlated with n_prod_prev and 3 other fields | High correlation |
tipo_ramo_name is highly correlated with tipo_prod_desc and 1 other fields | High correlation |
tipo_prod_desc is highly correlated with tipo_ramo_name and 1 other fields | High correlation |
NumeroPoliza__c is highly correlated with tipo_ramo_name and 1 other fields | High correlation |
FechaInicioVigencia__ctrim is highly correlated with churn | High correlation |
churn is highly correlated with FechaInicioVigencia__ctrim | High correlation |
n_prod_prev is highly correlated with PuntoVenta__c and 2 other fields | High correlation |
total_siniestros is highly correlated with PuntoVenta__c and 2 other fields | High correlation |
total_pagado_smmlv is highly correlated with PuntoVenta__c and 3 other fields | High correlation |
anios_ultimo_siniestro is highly correlated with PuntoVenta__c and 2 other fields | High correlation |
AnnualRevenue is highly correlated with OtrosIngresos__c and 1 other fields | High correlation |
OtrosIngresos__c is highly correlated with anios_ultimo_siniestro and 1 other fields | High correlation |
EgresosAnuales__c is highly correlated with AnnualRevenue and 1 other fields | High correlation |
EstadoCivil__pc is highly correlated with Genero__pc | High correlation |
Genero__pc is highly correlated with EgresosAnuales__c and 1 other fields | High correlation |
MarcaVehiculo__c has 37709 (100.0%) missing values | Missing |
MdeloVehiculo__c has 37709 (100.0%) missing values | Missing |
n_prod_prev has 1218 (3.2%) missing values | Missing |
total_siniestros has 21451 (56.9%) missing values | Missing |
total_pagado_smmlv has 21451 (56.9%) missing values | Missing |
anios_ultimo_siniestro has 21451 (56.9%) missing values | Missing |
Activos__c has 14609 (38.7%) missing values | Missing |
AnnualRevenue has 14609 (38.7%) missing values | Missing |
MontoAnual__c has 37682 (99.9%) missing values | Missing |
OtrosIngresos__c has 16905 (44.8%) missing values | Missing |
Profesion__pc has 37709 (100.0%) missing values | Missing |
EgresosAnuales__c has 14609 (38.7%) missing values | Missing |
EstadoCivil__pc has 14347 (38.0%) missing values | Missing |
Genero__pc has 14347 (38.0%) missing values | Missing |
ciudad_name has 14347 (38.0%) missing values | Missing |
edad has 14420 (38.2%) missing values | Missing |
Activos__c is highly skewed (γ1 = 103.1264111) | Skewed |
AnnualRevenue is highly skewed (γ1 = 23.01222549) | Skewed |
OtrosIngresos__c is highly skewed (γ1 = 81.18737292) | Skewed |
MarcaVehiculo__c is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
MdeloVehiculo__c is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Profesion__pc is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
total_pagado_smmlv has 1856 (4.9%) zeros | Zeros |
OtrosIngresos__c has 19756 (52.4%) zeros | Zeros |
Reproduction
| Analysis started | 2022-06-08 19:27:35.425034 |
|---|---|
| Analysis finished | 2022-06-08 19:33:27.220190 |
| Duration | 5 minutes and 51.8 seconds |
| Software version | pandas-profiling v3.2.0 |
| Download configuration | config.json |
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.1 MiB |
| 1 | |
|---|---|
| 4 | 625 |
| 3 | 155 |
| 2 | 66 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 37709 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 36863 | |
| 4 | 625 | 1.7% |
| 3 | 155 | 0.4% |
| 2 | 66 | 0.2% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| 1 | 36863 | |
| 4 | 625 | 1.7% |
| 3 | 155 | 0.4% |
| 2 | 66 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 36863 | |
| 4 | 625 | 1.7% |
| 3 | 155 | 0.4% |
| 2 | 66 | 0.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 37709 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 36863 | |
| 4 | 625 | 1.7% |
| 3 | 155 | 0.4% |
| 2 | 66 | 0.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 37709 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 36863 | |
| 4 | 625 | 1.7% |
| 3 | 155 | 0.4% |
| 2 | 66 | 0.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 37709 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 36863 | |
| 4 | 625 | 1.7% |
| 3 | 155 | 0.4% |
| 2 | 66 | 0.2% |
| Distinct | 283 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3909.493569 |
| Minimum | 5 |
|---|---|
| Maximum | 20007 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 294.7 KiB |
Quantile statistics
| Minimum | 5 |
|---|---|
| 5-th percentile | 103 |
| Q1 | 1048 |
| median | 2468 |
| Q3 | 9467 |
| 95-th percentile | 9721 |
| Maximum | 20007 |
| Range | 20002 |
| Interquartile range (IQR) | 8419 |
Descriptive statistics
| Standard deviation | 3649.840905 |
|---|---|
| Coefficient of variation (CV) | 0.9335840667 |
| Kurtosis | -1.068064972 |
| Mean | 3909.493569 |
| Median Absolute Deviation (MAD) | 1468 |
| Skewness | 0.7700464119 |
| Sum | 147423093 |
| Variance | 13321338.63 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 9721 | 7161 | |
| 3301 | 2106 | 5.6% |
| 1048 | 1758 | 4.7% |
| 3202 | 1697 | 4.5% |
| 103 | 1531 | 4.1% |
| 404 | 1501 | 4.0% |
| 2466 | 1433 | 3.8% |
| 301 | 1261 | 3.3% |
| 3502 | 1250 | 3.3% |
| 1503 | 1015 | 2.7% |
| Other values (273) | 16996 |
| Value | Count | Frequency (%) |
| 5 | 175 | 0.5% |
| 8 | 32 | 0.1% |
| 9 | 54 | 0.1% |
| 14 | 140 | 0.4% |
| 16 | 121 | 0.3% |
| 23 | 504 | |
| 25 | 126 | 0.3% |
| 26 | 92 | 0.2% |
| 100 | 1 | < 0.1% |
| 102 | 9 | < 0.1% |
| Value | Count | Frequency (%) |
| 20007 | 2 | < 0.1% |
| 10111 | 2 | < 0.1% |
| 9977 | 8 | < 0.1% |
| 9974 | 2 | < 0.1% |
| 9973 | 1 | < 0.1% |
| 9972 | 5 | < 0.1% |
| 9971 | 75 | |
| 9970 | 4 | < 0.1% |
| 9969 | 51 | |
| 9967 | 9 | < 0.1% |
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.4 MiB |
| automoviles | |
|---|---|
| previhogar | 3216 |
| responsabilidad civil | 96 |
Length
| Max length | 21 |
|---|---|
| Median length | 11 |
| Mean length | 10.94017343 |
| Min length | 10 |
Characters and Unicode
| Total characters | 412543 |
|---|---|
| Distinct characters | 19 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | previhogar |
|---|---|
| 2nd row | previhogar |
| 3rd row | previhogar |
| 4th row | previhogar |
| 5th row | previhogar |
Common Values
| Value | Count | Frequency (%) |
| automoviles | 34397 | |
| previhogar | 3216 | 8.5% |
| responsabilidad civil | 96 | 0.3% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| automoviles | 34397 | |
| previhogar | 3216 | 8.5% |
| responsabilidad | 96 | 0.3% |
| civil | 96 | 0.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 72106 | |
| i | 37997 | |
| a | 37805 | |
| e | 37709 | |
| v | 37709 | |
| l | 34589 | |
| s | 34589 | |
| m | 34397 | |
| t | 34397 | |
| u | 34397 | |
| Other values (9) | 16848 | 4.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 412447 | |
| Space Separator | 96 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 72106 | |
| i | 37997 | |
| a | 37805 | |
| e | 37709 | |
| v | 37709 | |
| l | 34589 | |
| s | 34589 | |
| m | 34397 | |
| t | 34397 | |
| u | 34397 | |
| Other values (8) | 16752 | 4.1% |
Space Separator
| Value | Count | Frequency (%) |
| 96 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 412447 | |
| Common | 96 | < 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 72106 | |
| i | 37997 | |
| a | 37805 | |
| e | 37709 | |
| v | 37709 | |
| l | 34589 | |
| s | 34589 | |
| m | 34397 | |
| t | 34397 | |
| u | 34397 | |
| Other values (8) | 16752 | 4.1% |
Common
| Value | Count | Frequency (%) |
| 96 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 412543 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 72106 | |
| i | 37997 | |
| a | 37805 | |
| e | 37709 | |
| v | 37709 | |
| l | 34589 | |
| s | 34589 | |
| m | 34397 | |
| t | 34397 | |
| u | 34397 | |
| Other values (9) | 16848 | 4.1% |
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.4 MiB |
| automoviles | |
|---|---|
| previhogar | 3216 |
| profesionales medicos | 56 |
| directores y administradores | 38 |
| servidores publicos | 2 |
Length
| Max length | 28 |
|---|---|
| Median length | 11 |
| Mean length | 10.94712138 |
| Min length | 10 |
Characters and Unicode
| Total characters | 412805 |
|---|---|
| Distinct characters | 21 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | previhogar |
|---|---|
| 2nd row | previhogar |
| 3rd row | previhogar |
| 4th row | previhogar |
| 5th row | previhogar |
Common Values
| Value | Count | Frequency (%) |
| automoviles | 34397 | |
| previhogar | 3216 | 8.5% |
| profesionales medicos | 56 | 0.1% |
| directores y administradores | 38 | 0.1% |
| servidores publicos | 2 | < 0.1% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| automoviles | 34397 | |
| previhogar | 3216 | 8.5% |
| profesionales | 56 | 0.1% |
| medicos | 56 | 0.1% |
| directores | 38 | 0.1% |
| y | 38 | 0.1% |
| administradores | 38 | 0.1% |
| servidores | 2 | < 0.1% |
| publicos | 2 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 72258 | |
| e | 37899 | |
| i | 37843 | |
| a | 37745 | |
| v | 37615 | |
| s | 34685 | |
| m | 34491 | |
| t | 34473 | |
| l | 34455 | |
| u | 34399 | |
| Other values (11) | 16942 | 4.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 412671 | |
| Space Separator | 134 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 72258 | |
| e | 37899 | |
| i | 37843 | |
| a | 37745 | |
| v | 37615 | |
| s | 34685 | |
| m | 34491 | |
| t | 34473 | |
| l | 34455 | |
| u | 34399 | |
| Other values (10) | 16808 | 4.1% |
Space Separator
| Value | Count | Frequency (%) |
| 134 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 412671 | |
| Common | 134 | < 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 72258 | |
| e | 37899 | |
| i | 37843 | |
| a | 37745 | |
| v | 37615 | |
| s | 34685 | |
| m | 34491 | |
| t | 34473 | |
| l | 34455 | |
| u | 34399 | |
| Other values (10) | 16808 | 4.1% |
Common
| Value | Count | Frequency (%) |
| 134 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 412805 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 72258 | |
| e | 37899 | |
| i | 37843 | |
| a | 37745 | |
| v | 37615 | |
| s | 34685 | |
| m | 34491 | |
| t | 34473 | |
| l | 34455 | |
| u | 34399 | |
| Other values (11) | 16942 | 4.1% |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.2 MiB |
| 99999 |
|---|
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 5 |
| Min length | 5 |
Characters and Unicode
| Total characters | 188545 |
|---|---|
| Distinct characters | 1 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 99999 |
|---|---|
| 2nd row | 99999 |
| 3rd row | 99999 |
| 4th row | 99999 |
| 5th row | 99999 |
Common Values
| Value | Count | Frequency (%) |
| 99999 | 37709 |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| 99999 | 37709 |
Most occurring characters
| Value | Count | Frequency (%) |
| 9 | 188545 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 188545 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 9 | 188545 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 188545 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 9 | 188545 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 188545 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 9 | 188545 |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.2 MiB |
| 99999 |
|---|
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 5 |
| Min length | 5 |
Characters and Unicode
| Total characters | 188545 |
|---|---|
| Distinct characters | 1 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 99999 |
|---|---|
| 2nd row | 99999 |
| 3rd row | 99999 |
| 4th row | 99999 |
| 5th row | 99999 |
Common Values
| Value | Count | Frequency (%) |
| 99999 | 37709 |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| 99999 | 37709 |
Most occurring characters
| Value | Count | Frequency (%) |
| 9 | 188545 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 188545 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 9 | 188545 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 188545 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 9 | 188545 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 188545 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 9 | 188545 |
| Distinct | 29609 |
|---|---|
| Distinct (%) | 78.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2863543.321 |
| Minimum | 1000001 |
|---|---|
| Maximum | 3173059 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 294.7 KiB |
Quantile statistics
| Minimum | 1000001 |
|---|---|
| 5-th percentile | 1004451.8 |
| Q1 | 3006964 |
| median | 3029704 |
| Q3 | 3075038 |
| 95-th percentile | 3129598.6 |
| Maximum | 3173059 |
| Range | 2173058 |
| Interquartile range (IQR) | 68074 |
Descriptive statistics
| Standard deviation | 584922.3783 |
|---|---|
| Coefficient of variation (CV) | 0.2042652451 |
| Kurtosis | 6.165415324 |
| Mean | 2863543.321 |
| Median Absolute Deviation (MAD) | 25132 |
| Skewness | -2.847314158 |
| Sum | 1.079813551 × 1011 |
| Variance | 3.421341887 × 1011 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1000408 | 7 | < 0.1% |
| 3007886 | 6 | < 0.1% |
| 3007900 | 6 | < 0.1% |
| 3007953 | 6 | < 0.1% |
| 1003679 | 6 | < 0.1% |
| 3007934 | 6 | < 0.1% |
| 3007923 | 6 | < 0.1% |
| 3004772 | 6 | < 0.1% |
| 3004670 | 6 | < 0.1% |
| 3007894 | 6 | < 0.1% |
| Other values (29599) | 37648 |
| Value | Count | Frequency (%) |
| 1000001 | 2 | |
| 1000002 | 2 | |
| 1000003 | 1 | |
| 1000004 | 1 | |
| 1000005 | 2 | |
| 1000006 | 1 | |
| 1000007 | 1 | |
| 1000022 | 2 | |
| 1000023 | 1 | |
| 1000024 | 1 |
| Value | Count | Frequency (%) |
| 3173059 | 1 | |
| 3173056 | 1 | |
| 3172855 | 1 | |
| 3172830 | 1 | |
| 3172803 | 1 | |
| 3171951 | 1 | |
| 3171790 | 1 | |
| 3170723 | 1 | |
| 3169512 | 1 | |
| 3169510 | 1 |
| Distinct | 11 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.3 MiB |
| 03-2018 | |
|---|---|
| 02-2018 | |
| 02-2019 | |
| 01-2019 | |
| 03-2020 | |
| Other values (6) |
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 7 |
| Min length | 7 |
Characters and Unicode
| Total characters | 263963 |
|---|---|
| Distinct characters | 7 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 01-2018 |
|---|---|
| 2nd row | 01-2018 |
| 3rd row | 01-2018 |
| 4th row | 01-2018 |
| 5th row | 01-2018 |
Common Values
| Value | Count | Frequency (%) |
| 03-2018 | 6043 | |
| 02-2018 | 5772 | |
| 02-2019 | 5340 | |
| 01-2019 | 5164 | |
| 03-2020 | 4583 | |
| 01-2018 | 4464 | |
| 02-2021 | 4225 | |
| 01-2021 | 2083 | 5.5% |
| 03-2019 | 26 | 0.1% |
| 02-2020 | 7 | < 0.1% |
Length
| Value | Count | Frequency (%) |
| 03-2018 | 6043 | |
| 02-2018 | 5772 | |
| 02-2019 | 5340 | |
| 01-2019 | 5164 | |
| 03-2020 | 4583 | |
| 01-2018 | 4464 | |
| 02-2021 | 4225 | |
| 01-2021 | 2083 | 5.5% |
| 03-2019 | 26 | 0.1% |
| 02-2020 | 7 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 80010 | |
| 2 | 63953 | |
| 1 | 44830 | |
| - | 37709 | |
| 8 | 16279 | 6.2% |
| 3 | 10652 | 4.0% |
| 9 | 10530 | 4.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 226254 | |
| Dash Punctuation | 37709 | 14.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 80010 | |
| 2 | 63953 | |
| 1 | 44830 | |
| 8 | 16279 | 7.2% |
| 3 | 10652 | 4.7% |
| 9 | 10530 | 4.7% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 37709 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 263963 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 80010 | |
| 2 | 63953 | |
| 1 | 44830 | |
| - | 37709 | |
| 8 | 16279 | 6.2% |
| 3 | 10652 | 4.0% |
| 9 | 10530 | 4.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 263963 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 80010 | |
| 2 | 63953 | |
| 1 | 44830 | |
| - | 37709 | |
| 8 | 16279 | 6.2% |
| 3 | 10652 | 4.0% |
| 9 | 10530 | 4.0% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.1 MiB |
| 1 | |
|---|---|
| 0 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 37709 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 26130 | |
| 0 | 11579 |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| 1 | 26130 | |
| 0 | 11579 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 26130 | |
| 0 | 11579 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 37709 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 26130 | |
| 0 | 11579 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 37709 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 26130 | |
| 0 | 11579 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 37709 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 26130 | |
| 0 | 11579 |
| Distinct | 11 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1218 |
| Missing (%) | 3.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.041434874 |
| Minimum | 1 |
|---|---|
| Maximum | 16 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 294.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 2 |
| Q3 | 5 |
| 95-th percentile | 10 |
| Maximum | 16 |
| Range | 15 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 3.174608732 |
|---|---|
| Coefficient of variation (CV) | 1.043786523 |
| Kurtosis | 7.148963851 |
| Mean | 3.041434874 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 2.60820907 |
| Sum | 110985 |
| Variance | 10.0781406 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 14855 | |
| 2 | 8460 | |
| 5 | 7592 | |
| 3 | 2473 | 6.6% |
| 14 | 1035 | 2.7% |
| 4 | 896 | 2.4% |
| 16 | 772 | 2.0% |
| 10 | 207 | 0.5% |
| 6 | 128 | 0.3% |
| 8 | 56 | 0.1% |
| (Missing) | 1218 | 3.2% |
| Value | Count | Frequency (%) |
| 1 | 14855 | |
| 2 | 8460 | |
| 3 | 2473 | 6.6% |
| 4 | 896 | 2.4% |
| 5 | 7592 | |
| 6 | 128 | 0.3% |
| 7 | 17 | < 0.1% |
| 8 | 56 | 0.1% |
| 10 | 207 | 0.5% |
| 14 | 1035 | 2.7% |
| Value | Count | Frequency (%) |
| 16 | 772 | 2.0% |
| 14 | 1035 | 2.7% |
| 10 | 207 | 0.5% |
| 8 | 56 | 0.1% |
| 7 | 17 | < 0.1% |
| 6 | 128 | 0.3% |
| 5 | 7592 | |
| 4 | 896 | 2.4% |
| 3 | 2473 | 6.6% |
| 2 | 8460 |
total_siniestros
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSING| Distinct | 74 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 21451 |
| Missing (%) | 56.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1594.383688 |
| Minimum | 1 |
|---|---|
| Maximum | 3466 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 294.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 704 |
| Q3 | 3466 |
| 95-th percentile | 3466 |
| Maximum | 3466 |
| Range | 3465 |
| Interquartile range (IQR) | 3464 |
Descriptive statistics
| Standard deviation | 1681.585853 |
|---|---|
| Coefficient of variation (CV) | 1.054693337 |
| Kurtosis | -1.933381206 |
| Mean | 1594.383688 |
| Median Absolute Deviation (MAD) | 703 |
| Skewness | 0.1978923917 |
| Sum | 25921490 |
| Variance | 2827730.981 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3466 | 7219 | 19.1% |
| 1 | 4059 | 10.8% |
| 2 | 1058 | 2.8% |
| 704 | 1035 | 2.7% |
| 136 | 772 | 2.0% |
| 3 | 455 | 1.2% |
| 4 | 288 | 0.8% |
| 5 | 262 | 0.7% |
| 92 | 207 | 0.5% |
| 7 | 168 | 0.4% |
| Other values (64) | 735 | 1.9% |
| (Missing) | 21451 |
| Value | Count | Frequency (%) |
| 1 | 4059 | |
| 2 | 1058 | 2.8% |
| 3 | 455 | 1.2% |
| 4 | 288 | 0.8% |
| 5 | 262 | 0.7% |
| 6 | 85 | 0.2% |
| 7 | 168 | 0.4% |
| 8 | 28 | 0.1% |
| 9 | 74 | 0.2% |
| 10 | 64 | 0.2% |
| Value | Count | Frequency (%) |
| 3466 | 7219 | |
| 2972 | 4 | < 0.1% |
| 2698 | 1 | < 0.1% |
| 1311 | 1 | < 0.1% |
| 770 | 1 | < 0.1% |
| 704 | 1035 | 2.7% |
| 543 | 5 | < 0.1% |
| 215 | 1 | < 0.1% |
| 179 | 1 | < 0.1% |
| 145 | 3 | < 0.1% |
total_pagado_smmlv
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSINGZEROS| Distinct | 2424 |
|---|---|
| Distinct (%) | 14.9% |
| Missing | 21451 |
| Missing (%) | 56.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11536.93594 |
| Minimum | 0 |
|---|---|
| Maximum | 64793.74852 |
| Zeros | 1856 |
| Zeros (%) | 4.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 294.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 9.045556586 |
| median | 5779.809377 |
| Q3 | 24921.89139 |
| 95-th percentile | 24921.89139 |
| Maximum | 64793.74852 |
| Range | 64793.74852 |
| Interquartile range (IQR) | 24912.84583 |
Descriptive statistics
| Standard deviation | 12080.92058 |
|---|---|
| Coefficient of variation (CV) | 1.04715157 |
| Kurtosis | -1.847329363 |
| Mean | 11536.93594 |
| Median Absolute Deviation (MAD) | 5779.809377 |
| Skewness | 0.2074928349 |
| Sum | 187567504.6 |
| Variance | 145948642.2 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 24921.89139 | 7219 | 19.1% |
| 0 | 1856 | 4.9% |
| 5779.809377 | 1035 | 2.7% |
| 1308.359896 | 772 | 2.0% |
| 506.8921899 | 207 | 0.5% |
| 41.55167503 | 87 | 0.2% |
| 133.4554683 | 71 | 0.2% |
| 205.1638361 | 54 | 0.1% |
| 794.1729883 | 32 | 0.1% |
| 289.5339288 | 29 | 0.1% |
| Other values (2414) | 4896 | 13.0% |
| (Missing) | 21451 |
| Value | Count | Frequency (%) |
| 0 | 1856 | |
| 0.01143934598 | 2 | < 0.1% |
| 0.02341413734 | 1 | < 0.1% |
| 0.05839231033 | 6 | < 0.1% |
| 0.0649709053 | 1 | < 0.1% |
| 0.06651725121 | 1 | < 0.1% |
| 0.068615991 | 2 | < 0.1% |
| 0.07482544489 | 4 | < 0.1% |
| 0.0807227466 | 9 | < 0.1% |
| 0.08208084051 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 64793.74852 | 4 | < 0.1% |
| 24921.89139 | 7219 | |
| 5779.809377 | 1035 | 2.7% |
| 3629.20443 | 2 | < 0.1% |
| 2962.748964 | 5 | < 0.1% |
| 2501.817204 | 2 | < 0.1% |
| 1308.359896 | 772 | 2.0% |
| 1295.661733 | 1 | < 0.1% |
| 1194.044419 | 2 | < 0.1% |
| 1124.784281 | 3 | < 0.1% |
anios_ultimo_siniestro
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSING| Distinct | 1151 |
|---|---|
| Distinct (%) | 7.1% |
| Missing | 21451 |
| Missing (%) | 56.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.6779281686 |
| Minimum | 0.002739726027 |
|---|---|
| Maximum | 10.69863014 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 294.7 KiB |
Quantile statistics
| Minimum | 0.002739726027 |
|---|---|
| 5-th percentile | 0.002739726027 |
| Q1 | 0.002739726027 |
| median | 0.03287671233 |
| Q3 | 1.290410959 |
| 95-th percentile | 2.783561644 |
| Maximum | 10.69863014 |
| Range | 10.69589041 |
| Interquartile range (IQR) | 1.287671233 |
Descriptive statistics
| Standard deviation | 1.046954504 |
|---|---|
| Coefficient of variation (CV) | 1.544344302 |
| Kurtosis | 5.311930213 |
| Mean | 0.6779281686 |
| Median Absolute Deviation (MAD) | 0.0301369863 |
| Skewness | 1.820966177 |
| Sum | 11021.75616 |
| Variance | 1.096113734 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.002739726027 | 7223 | 19.2% |
| 0.0602739726 | 1044 | 2.8% |
| 0.008219178082 | 803 | 2.1% |
| 0.04383561644 | 209 | 0.6% |
| 0.08767123288 | 92 | 0.2% |
| 0.4328767123 | 90 | 0.2% |
| 0.1534246575 | 67 | 0.2% |
| 0.07671232877 | 47 | 0.1% |
| 1.449315068 | 35 | 0.1% |
| 1.684931507 | 32 | 0.1% |
| Other values (1141) | 6616 | 17.5% |
| (Missing) | 21451 |
| Value | Count | Frequency (%) |
| 0.002739726027 | 7223 | |
| 0.005479452055 | 13 | < 0.1% |
| 0.008219178082 | 803 | 2.1% |
| 0.01095890411 | 15 | < 0.1% |
| 0.01369863014 | 23 | 0.1% |
| 0.01643835616 | 11 | < 0.1% |
| 0.01917808219 | 4 | < 0.1% |
| 0.02465753425 | 9 | < 0.1% |
| 0.02739726027 | 2 | < 0.1% |
| 0.0301369863 | 25 | 0.1% |
| Value | Count | Frequency (%) |
| 10.69863014 | 2 | < 0.1% |
| 10.00273973 | 6 | |
| 9.095890411 | 1 | < 0.1% |
| 7.923287671 | 1 | < 0.1% |
| 7.509589041 | 2 | < 0.1% |
| 7.282191781 | 1 | < 0.1% |
| 7.082191781 | 2 | < 0.1% |
| 6.97260274 | 1 | < 0.1% |
| 6.81369863 | 1 | < 0.1% |
| 6.668493151 | 2 | < 0.1% |
| Distinct | 3955 |
|---|---|
| Distinct (%) | 17.1% |
| Missing | 14609 |
| Missing (%) | 38.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 437803920.1 |
| Minimum | 0 |
|---|---|
| Maximum | 1 × 1012 |
| Zeros | 24 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 294.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 22000000 |
| Q1 | 62900000 |
| median | 126000000 |
| Q3 | 280000000 |
| 95-th percentile | 1040376850 |
| Maximum | 1 × 1012 |
| Range | 1 × 1012 |
| Interquartile range (IQR) | 217100000 |
Descriptive statistics
| Standard deviation | 9434661146 |
|---|---|
| Coefficient of variation (CV) | 21.54996955 |
| Kurtosis | 10909.77113 |
| Mean | 437803920.1 |
| Median Absolute Deviation (MAD) | 76000000 |
| Skewness | 103.1264111 |
| Sum | 1.011327055 × 1013 |
| Variance | 8.901283094 × 1019 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 100000000 | 1139 | 3.0% |
| 80000000 | 859 | 2.3% |
| 200000000 | 805 | 2.1% |
| 150000000 | 801 | 2.1% |
| 50000000 | 687 | 1.8% |
| 120000000 | 633 | 1.7% |
| 60000000 | 592 | 1.6% |
| 40000000 | 494 | 1.3% |
| 90000000 | 470 | 1.2% |
| 30000000 | 464 | 1.2% |
| Other values (3945) | 16156 | |
| (Missing) | 14609 |
| Value | Count | Frequency (%) |
| 0 | 24 | 0.1% |
| 1 | 76 | |
| 2 | 3 | < 0.1% |
| 20 | 2 | < 0.1% |
| 40 | 3 | < 0.1% |
| 50 | 1 | < 0.1% |
| 80 | 1 | < 0.1% |
| 100 | 3 | < 0.1% |
| 104 | 1 | < 0.1% |
| 350 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 × 1012 | 2 | |
| 1 × 1011 | 2 | |
| 5.835 × 1010 | 1 | < 0.1% |
| 5.43154931 × 1010 | 1 | < 0.1% |
| 4.479 × 1010 | 1 | < 0.1% |
| 4.0078653 × 1010 | 4 | |
| 3.1092794 × 1010 | 3 | |
| 2.8125029 × 1010 | 2 | |
| 2.43 × 1010 | 1 | < 0.1% |
| 2.0615603 × 1010 | 1 | < 0.1% |
AnnualRevenue
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSINGSKEWED| Distinct | 3904 |
|---|---|
| Distinct (%) | 16.9% |
| Missing | 14609 |
| Missing (%) | 38.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 235281369.7 |
| Minimum | 0 |
|---|---|
| Maximum | 8.63 × 1010 |
| Zeros | 8 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 294.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 8500000 |
| Q1 | 26000000 |
| median | 45000000 |
| Q3 | 84000000 |
| 95-th percentile | 538284000 |
| Maximum | 8.63 × 1010 |
| Range | 8.63 × 1010 |
| Interquartile range (IQR) | 58000000 |
Descriptive statistics
| Standard deviation | 1615782969 |
|---|---|
| Coefficient of variation (CV) | 6.86744969 |
| Kurtosis | 790.166724 |
| Mean | 235281369.7 |
| Median Absolute Deviation (MAD) | 23000000 |
| Skewness | 23.01222549 |
| Sum | 5.434999639 × 1012 |
| Variance | 2.610754603 × 1018 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 36000000 | 1175 | 3.1% |
| 60000000 | 921 | 2.4% |
| 24000000 | 898 | 2.4% |
| 30000000 | 834 | 2.2% |
| 48000000 | 708 | 1.9% |
| 18000000 | 490 | 1.3% |
| 50000000 | 434 | 1.2% |
| 12000000 | 408 | 1.1% |
| 40000000 | 407 | 1.1% |
| 42000000 | 342 | 0.9% |
| Other values (3894) | 16483 | |
| (Missing) | 14609 |
| Value | Count | Frequency (%) |
| 0 | 8 | < 0.1% |
| 1 | 28 | |
| 20 | 2 | < 0.1% |
| 52230 | 1 | < 0.1% |
| 250000 | 1 | < 0.1% |
| 328000 | 1 | < 0.1% |
| 350000 | 1 | < 0.1% |
| 500000 | 3 | < 0.1% |
| 600000 | 1 | < 0.1% |
| 700000 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 8.63 × 1010 | 1 | < 0.1% |
| 6.6728 × 1010 | 1 | < 0.1% |
| 6 × 1010 | 2 | < 0.1% |
| 4.1610143 × 1010 | 2 | < 0.1% |
| 3.6110425 × 1010 | 5 | |
| 3.5084 × 1010 | 2 | < 0.1% |
| 2.6097952 × 1010 | 2 | < 0.1% |
| 2.576590619 × 1010 | 2 | < 0.1% |
| 2.469016564 × 1010 | 3 | |
| 2.3626255 × 1010 | 2 | < 0.1% |
| Distinct | 12 |
|---|---|
| Distinct (%) | 44.4% |
| Missing | 37682 |
| Missing (%) | 99.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1857979.296 |
| Minimum | 0 |
|---|---|
| Maximum | 50000000 |
| Zeros | 10 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 294.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 600 |
| Q3 | 18000 |
| 95-th percentile | 23981.5 |
| Maximum | 50000000 |
| Range | 50000000 |
| Interquartile range (IQR) | 18000 |
Descriptive statistics
| Standard deviation | 9621283.821 |
|---|---|
| Coefficient of variation (CV) | 5.178359006 |
| Kurtosis | 26.99995075 |
| Mean | 1857979.296 |
| Median Absolute Deviation (MAD) | 600 |
| Skewness | 5.196145569 |
| Sum | 50165441 |
| Variance | 9.256910237 × 1013 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 10 | < 0.1% |
| 18000 | 4 | < 0.1% |
| 3000 | 3 | < 0.1% |
| 21605 | 2 | < 0.1% |
| 10000 | 1 | < 0.1% |
| 5525 | 1 | < 0.1% |
| 600 | 1 | < 0.1% |
| 50000000 | 1 | < 0.1% |
| 25000 | 1 | < 0.1% |
| 5 | 1 | < 0.1% |
| Other values (2) | 2 | < 0.1% |
| (Missing) | 37682 |
| Value | Count | Frequency (%) |
| 0 | 10 | |
| 1 | 1 | < 0.1% |
| 5 | 1 | < 0.1% |
| 100 | 1 | < 0.1% |
| 600 | 1 | < 0.1% |
| 3000 | 3 | < 0.1% |
| 5525 | 1 | < 0.1% |
| 10000 | 1 | < 0.1% |
| 18000 | 4 | < 0.1% |
| 21605 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 50000000 | 1 | < 0.1% |
| 25000 | 1 | < 0.1% |
| 21605 | 2 | |
| 18000 | 4 | |
| 10000 | 1 | < 0.1% |
| 5525 | 1 | < 0.1% |
| 3000 | 3 | |
| 600 | 1 | < 0.1% |
| 100 | 1 | < 0.1% |
| 5 | 1 | < 0.1% |
| Distinct | 292 |
|---|---|
| Distinct (%) | 1.4% |
| Missing | 16905 |
| Missing (%) | 44.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2793906.203 |
| Minimum | 0 |
|---|---|
| Maximum | 8400000000 |
| Zeros | 19756 |
| Zeros (%) | 52.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 294.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 200000 |
| Maximum | 8400000000 |
| Range | 8400000000 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 74595168.14 |
|---|---|
| Coefficient of variation (CV) | 26.69923853 |
| Kurtosis | 8216.563948 |
| Mean | 2793906.203 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 81.18737292 |
| Sum | 5.812442464 × 1010 |
| Variance | 5.56443911 × 1015 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 19756 | |
| 12000000 | 58 | 0.2% |
| 10000000 | 40 | 0.1% |
| 6000000 | 35 | 0.1% |
| 30000000 | 32 | 0.1% |
| 24000000 | 31 | 0.1% |
| 5000000 | 27 | 0.1% |
| 18000000 | 22 | 0.1% |
| 20000000 | 19 | 0.1% |
| 15000000 | 18 | < 0.1% |
| Other values (282) | 766 | 2.0% |
| (Missing) | 16905 |
| Value | Count | Frequency (%) |
| 0 | 19756 | |
| 9583 | 1 | < 0.1% |
| 24000 | 2 | < 0.1% |
| 178000 | 2 | < 0.1% |
| 183000 | 1 | < 0.1% |
| 200000 | 6 | < 0.1% |
| 201105 | 2 | < 0.1% |
| 228000 | 1 | < 0.1% |
| 239000 | 1 | < 0.1% |
| 240000 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 8400000000 | 1 | < 0.1% |
| 3439000000 | 2 | < 0.1% |
| 1664801000 | 5 | |
| 936054000 | 1 | < 0.1% |
| 928737000 | 2 | < 0.1% |
| 862423500 | 2 | < 0.1% |
| 590960000 | 3 | |
| 436838000 | 1 | < 0.1% |
| 398188968 | 1 | < 0.1% |
| 268346000 | 3 |
EgresosAnuales__c
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSING| Distinct | 2996 |
|---|---|
| Distinct (%) | 13.0% |
| Missing | 14609 |
| Missing (%) | 38.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 153383472.9 |
| Minimum | 0 |
|---|---|
| Maximum | 3.6967344 × 1010 |
| Zeros | 15 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 294.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3000000 |
| Q1 | 12000000 |
| median | 24000000 |
| Q3 | 50000000 |
| 95-th percentile | 401471000 |
| Maximum | 3.6967344 × 1010 |
| Range | 3.6967344 × 1010 |
| Interquartile range (IQR) | 38000000 |
Descriptive statistics
| Standard deviation | 1013404716 |
|---|---|
| Coefficient of variation (CV) | 6.607000724 |
| Kurtosis | 471.1053889 |
| Mean | 153383472.9 |
| Median Absolute Deviation (MAD) | 14000000 |
| Skewness | 18.8050108 |
| Sum | 3.543158223 × 1012 |
| Variance | 1.026989119 × 1018 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 12000000 | 1200 | 3.2% |
| 30000000 | 1011 | 2.7% |
| 24000000 | 949 | 2.5% |
| 18000000 | 903 | 2.4% |
| 20000000 | 884 | 2.3% |
| 36000000 | 544 | 1.4% |
| 10000000 | 519 | 1.4% |
| 15000000 | 517 | 1.4% |
| 40000000 | 511 | 1.4% |
| 25000000 | 445 | 1.2% |
| Other values (2986) | 15617 | |
| (Missing) | 14609 |
| Value | Count | Frequency (%) |
| 0 | 15 | < 0.1% |
| 1 | 153 | |
| 10 | 8 | < 0.1% |
| 18 | 1 | < 0.1% |
| 100 | 1 | < 0.1% |
| 204 | 2 | < 0.1% |
| 20000 | 1 | < 0.1% |
| 50000 | 2 | < 0.1% |
| 70000 | 1 | < 0.1% |
| 72000 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 3.6967344 × 1010 | 2 | < 0.1% |
| 3.0868341 × 1010 | 5 | |
| 2.2582482 × 1010 | 2 | < 0.1% |
| 2.166849912 × 1010 | 4 | |
| 2.1322738 × 1010 | 2 | < 0.1% |
| 1.9746108 × 1010 | 2 | < 0.1% |
| 1.923885007 × 1010 | 3 | |
| 1.8035021 × 1010 | 1 | < 0.1% |
| 1.629516502 × 1010 | 2 | < 0.1% |
| 1.4868 × 1010 | 2 | < 0.1% |
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 14347 |
| Missing (%) | 38.0% |
| Memory size | 1.8 MiB |
| SOLTERO | |
|---|---|
| CASADO | |
| OTRO | |
| UNIDO | 307 |
| VIUDO | 81 |
| Other values (3) | 134 |
Length
| Max length | 10 |
|---|---|
| Median length | 8 |
| Mean length | 6.324929372 |
| Min length | 3 |
Characters and Unicode
| Total characters | 147763 |
|---|---|
| Distinct characters | 15 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | SOLTERO |
|---|---|
| 2nd row | CASADO |
| 3rd row | SOLTERO |
| 4th row | CASADO |
| 5th row | SOLTERO |
Common Values
| Value | Count | Frequency (%) |
| SOLTERO | 10974 | |
| CASADO | 10226 | |
| OTRO | 1640 | 4.3% |
| UNIDO | 307 | 0.8% |
| VIUDO | 81 | 0.2% |
| SEPARADO | 73 | 0.2% |
| DIVORCIADO | 46 | 0.1% |
| N A | 15 | < 0.1% |
| (Missing) | 14347 |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| soltero | 10974 | |
| casado | 10226 | |
| otro | 1640 | 7.0% |
| unido | 307 | 1.3% |
| viudo | 81 | 0.3% |
| separado | 73 | 0.3% |
| divorciado | 46 | 0.2% |
| n | 15 | 0.1% |
| a | 15 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| O | 36007 | |
| S | 21273 | |
| A | 20659 | |
| R | 12733 | 8.6% |
| T | 12614 | 8.5% |
| E | 11047 | 7.5% |
| L | 10974 | 7.4% |
| D | 10779 | 7.3% |
| C | 10272 | 7.0% |
| I | 480 | 0.3% |
| Other values (5) | 925 | 0.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 147748 | |
| Space Separator | 15 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 36007 | |
| S | 21273 | |
| A | 20659 | |
| R | 12733 | 8.6% |
| T | 12614 | 8.5% |
| E | 11047 | 7.5% |
| L | 10974 | 7.4% |
| D | 10779 | 7.3% |
| C | 10272 | 7.0% |
| I | 480 | 0.3% |
| Other values (4) | 910 | 0.6% |
Space Separator
| Value | Count | Frequency (%) |
| 15 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 147748 | |
| Common | 15 | < 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| O | 36007 | |
| S | 21273 | |
| A | 20659 | |
| R | 12733 | 8.6% |
| T | 12614 | 8.5% |
| E | 11047 | 7.5% |
| L | 10974 | 7.4% |
| D | 10779 | 7.3% |
| C | 10272 | 7.0% |
| I | 480 | 0.3% |
| Other values (4) | 910 | 0.6% |
Common
| Value | Count | Frequency (%) |
| 15 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 147763 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| O | 36007 | |
| S | 21273 | |
| A | 20659 | |
| R | 12733 | 8.6% |
| T | 12614 | 8.5% |
| E | 11047 | 7.5% |
| L | 10974 | 7.4% |
| D | 10779 | 7.3% |
| C | 10272 | 7.0% |
| I | 480 | 0.3% |
| Other values (5) | 925 | 0.6% |
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 14347 |
| Missing (%) | 38.0% |
| Memory size | 1.9 MiB |
| MASCULINO | |
|---|---|
| FEMENINO | |
| N A | 8 |
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 8.733070799 |
| Min length | 3 |
Characters and Unicode
| Total characters | 204022 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | MASCULINO |
|---|---|
| 2nd row | FEMENINO |
| 3rd row | MASCULINO |
| 4th row | MASCULINO |
| 5th row | FEMENINO |
Common Values
| Value | Count | Frequency (%) |
| MASCULINO | 17166 | |
| FEMENINO | 6188 | 16.4% |
| N A | 8 | < 0.1% |
| (Missing) | 14347 |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| masculino | 17166 | |
| femenino | 6188 | 26.5% |
| n | 8 | < 0.1% |
| a | 8 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| N | 29550 | |
| M | 23354 | |
| I | 23354 | |
| O | 23354 | |
| A | 17174 | |
| S | 17166 | |
| C | 17166 | |
| U | 17166 | |
| L | 17166 | |
| E | 12376 | |
| Other values (2) | 6196 | 3.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 204014 | |
| Space Separator | 8 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 29550 | |
| M | 23354 | |
| I | 23354 | |
| O | 23354 | |
| A | 17174 | |
| S | 17166 | |
| C | 17166 | |
| U | 17166 | |
| L | 17166 | |
| E | 12376 |
Space Separator
| Value | Count | Frequency (%) |
| 8 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 204014 | |
| Common | 8 | < 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| N | 29550 | |
| M | 23354 | |
| I | 23354 | |
| O | 23354 | |
| A | 17174 | |
| S | 17166 | |
| C | 17166 | |
| U | 17166 | |
| L | 17166 | |
| E | 12376 |
Common
| Value | Count | Frequency (%) |
| 8 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 204022 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| N | 29550 | |
| M | 23354 | |
| I | 23354 | |
| O | 23354 | |
| A | 17174 | |
| S | 17166 | |
| C | 17166 | |
| U | 17166 | |
| L | 17166 | |
| E | 12376 | |
| Other values (2) | 6196 | 3.0% |
| Distinct | 22 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 14347 |
| Missing (%) | 38.0% |
| Memory size | 1.9 MiB |
| otras | |
|---|---|
| BOGOTÁ D.C. | 1726 |
| MEDELLIN | 738 |
| CALI | 688 |
| CARTAGENA | 195 |
| Other values (17) |
Length
| Max length | 13 |
|---|---|
| Median length | 5 |
| Mean length | 5.792825957 |
| Min length | 4 |
Characters and Unicode
| Total characters | 135332 |
|---|---|
| Distinct characters | 31 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | otras |
|---|---|
| 2nd row | otras |
| 3rd row | otras |
| 4th row | PASTO |
| 5th row | otras |
Common Values
| Value | Count | Frequency (%) |
| otras | 18170 | |
| BOGOTÁ D.C. | 1726 | 4.6% |
| MEDELLIN | 738 | 2.0% |
| CALI | 688 | 1.8% |
| CARTAGENA | 195 | 0.5% |
| ARMENIA | 192 | 0.5% |
| VILLAVICENCIO | 189 | 0.5% |
| BUCARAMANGA | 184 | 0.5% |
| PASTO | 182 | 0.5% |
| YOPAL | 173 | 0.5% |
| Other values (12) | 925 | 2.5% |
| (Missing) | 14347 |
Length
| Value | Count | Frequency (%) |
| otras | 18170 | |
| bogotá | 1726 | 6.8% |
| d.c | 1726 | 6.8% |
| medellin | 738 | 2.9% |
| cali | 688 | 2.7% |
| cartagena | 195 | 0.8% |
| armenia | 192 | 0.8% |
| villavicencio | 189 | 0.7% |
| bucaramanga | 184 | 0.7% |
| pasto | 182 | 0.7% |
| Other values (17) | 1241 | 4.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 18170 | |
| r | 18170 | |
| a | 18170 | |
| s | 18170 | |
| t | 18170 | |
| A | 4333 | 3.2% |
| O | 4228 | 3.1% |
| C | 3520 | 2.6% |
| . | 3452 | 2.6% |
| L | 3201 | 2.4% |
| Other values (21) | 25748 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 90850 | |
| Uppercase Letter | 39161 | |
| Other Punctuation | 3452 | 2.6% |
| Space Separator | 1869 | 1.4% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 4333 | |
| O | 4228 | |
| C | 3520 | 9.0% |
| L | 3201 | 8.2% |
| I | 2872 | 7.3% |
| E | 2682 | 6.8% |
| D | 2600 | 6.6% |
| T | 2283 | 5.8% |
| G | 2222 | 5.7% |
| B | 2079 | 5.3% |
| Other values (14) | 9141 |
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 18170 | |
| r | 18170 | |
| a | 18170 | |
| s | 18170 | |
| t | 18170 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 3452 |
Space Separator
| Value | Count | Frequency (%) |
| 1869 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 130011 | |
| Common | 5321 | 3.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 18170 | |
| r | 18170 | |
| a | 18170 | |
| s | 18170 | |
| t | 18170 | |
| A | 4333 | 3.3% |
| O | 4228 | 3.3% |
| C | 3520 | 2.7% |
| L | 3201 | 2.5% |
| I | 2872 | 2.2% |
| Other values (19) | 21007 |
Common
| Value | Count | Frequency (%) |
| . | 3452 | |
| 1869 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 133337 | |
| None | 1995 | 1.5% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 18170 | |
| r | 18170 | |
| a | 18170 | |
| s | 18170 | |
| t | 18170 | |
| A | 4333 | 3.2% |
| O | 4228 | 3.2% |
| C | 3520 | 2.6% |
| . | 3452 | 2.6% |
| L | 3201 | 2.4% |
| Other values (18) | 23753 |
None
| Value | Count | Frequency (%) |
| Á | 1810 | |
| Ú | 125 | 6.3% |
| É | 60 | 3.0% |
| Distinct | 10412 |
|---|---|
| Distinct (%) | 44.7% |
| Missing | 14420 |
| Missing (%) | 38.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 50.56917858 |
| Minimum | 1.4 |
|---|---|
| Maximum | 122.5150685 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 294.7 KiB |
Quantile statistics
| Minimum | 1.4 |
|---|---|
| 5-th percentile | 29.23013699 |
| Q1 | 39.89041096 |
| median | 49.82191781 |
| Q3 | 60.46027397 |
| 95-th percentile | 74.17589041 |
| Maximum | 122.5150685 |
| Range | 121.1150685 |
| Interquartile range (IQR) | 20.56986301 |
Descriptive statistics
| Standard deviation | 14.2289308 |
|---|---|
| Coefficient of variation (CV) | 0.2813755571 |
| Kurtosis | 0.4070367718 |
| Mean | 50.56917858 |
| Median Absolute Deviation (MAD) | 10.25479452 |
| Skewness | 0.3681551313 |
| Sum | 1177705.6 |
| Variance | 202.4624716 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 46.69315068 | 80 | 0.2% |
| 47.52054795 | 77 | 0.2% |
| 42.4630137 | 46 | 0.1% |
| 122.5150685 | 31 | 0.1% |
| 43.69041096 | 22 | 0.1% |
| 41.58630137 | 21 | 0.1% |
| 57.71232877 | 20 | 0.1% |
| 36.51232877 | 20 | 0.1% |
| 51.69041096 | 19 | 0.1% |
| 60.55890411 | 19 | 0.1% |
| Other values (10402) | 22934 | |
| (Missing) | 14420 |
| Value | Count | Frequency (%) |
| 1.4 | 1 | |
| 3.378082192 | 1 | |
| 3.410958904 | 1 | |
| 4.235616438 | 1 | |
| 4.260273973 | 1 | |
| 4.339726027 | 1 | |
| 4.353424658 | 2 | |
| 4.4 | 1 | |
| 4.432876712 | 2 | |
| 4.767123288 | 1 |
| Value | Count | Frequency (%) |
| 122.5150685 | 31 | |
| 104.9589041 | 2 | < 0.1% |
| 103.0767123 | 3 | < 0.1% |
| 100.0219178 | 1 | < 0.1% |
| 98.50136986 | 2 | < 0.1% |
| 96.36712329 | 2 | < 0.1% |
| 96.29863014 | 2 | < 0.1% |
| 96.10958904 | 1 | < 0.1% |
| 95.52054795 | 2 | < 0.1% |
| 95.43835616 | 14 |
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| CodigoTipoAsegurado__c | PuntoVenta__c | tipo_ramo_name | tipo_prod_desc | ClaseVehiculo__c | MarcaVehiculo__c | MdeloVehiculo__c | TipoVehiculo__c | NumeroPoliza__c | FechaInicioVigencia__ctrim | churn | n_prod_prev | total_siniestros | total_pagado_smmlv | anios_ultimo_siniestro | Activos__c | AnnualRevenue | MontoAnual__c | OtrosIngresos__c | Profesion__pc | EgresosAnuales__c | EstadoCivil__pc | Genero__pc | ciudad_name | edad | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | 404 | previhogar | previhogar | 99999 | NaN | NaN | 99999 | 1003658 | 01-2018 | 0 | 2.0 | NaN | NaN | NaN | 1.320000e+08 | 7.000000e+05 | NaN | NaN | NaN | 1.000000e+00 | SOLTERO | MASCULINO | otras | 49.230137 |
| 1 | 1 | 103 | previhogar | previhogar | 99999 | NaN | NaN | 99999 | 1002245 | 01-2018 | 0 | 2.0 | NaN | NaN | NaN | 3.000000e+07 | 2.090000e+07 | NaN | NaN | NaN | 1.820000e+07 | CASADO | FEMENINO | otras | 83.964384 |
| 2 | 1 | 5 | previhogar | previhogar | 99999 | NaN | NaN | 99999 | 1000059 | 01-2018 | 1 | 2.0 | 1.0 | 0.000000 | 1.739726 | 3.434361e+09 | 7.238820e+08 | NaN | 0.0 | NaN | 5.662310e+08 | SOLTERO | MASCULINO | otras | 37.361644 |
| 3 | 1 | 1402 | previhogar | previhogar | 99999 | NaN | NaN | 99999 | 1000596 | 01-2018 | 1 | 4.0 | 1.0 | 1.567125 | 2.400000 | 4.260000e+08 | 1.123034e+08 | NaN | 100000000.0 | NaN | 9.600000e+07 | CASADO | MASCULINO | PASTO | 50.134247 |
| 4 | 1 | 7002 | previhogar | previhogar | 99999 | NaN | NaN | 99999 | 1001130 | 01-2018 | 1 | 2.0 | NaN | NaN | NaN | 6.000000e+07 | 2.900000e+07 | NaN | NaN | NaN | 2.900000e+07 | SOLTERO | FEMENINO | otras | 37.079452 |
| 5 | 1 | 7007 | previhogar | previhogar | 99999 | NaN | NaN | 99999 | 1001131 | 01-2018 | 1 | 6.0 | NaN | NaN | NaN | 2.068315e+08 | 7.445627e+07 | NaN | 0.0 | NaN | 6.645600e+07 | OTRO | MASCULINO | BOGOTÁ D.C. | 38.356164 |
| 6 | 1 | 404 | previhogar | previhogar | 99999 | NaN | NaN | 99999 | 1003433 | 01-2018 | 0 | 2.0 | NaN | NaN | NaN | 6.000000e+08 | 4.900000e+07 | NaN | NaN | NaN | 3.500000e+07 | OTRO | FEMENINO | otras | 78.435616 |
| 7 | 1 | 404 | previhogar | previhogar | 99999 | NaN | NaN | 99999 | 1003236 | 01-2018 | 1 | 2.0 | NaN | NaN | NaN | 1.700000e+08 | 3.600000e+07 | NaN | NaN | NaN | 2.400000e+07 | OTRO | FEMENINO | CALI | 72.476712 |
| 8 | 1 | 404 | previhogar | previhogar | 99999 | NaN | NaN | 99999 | 1003090 | 01-2018 | 0 | 1.0 | NaN | NaN | NaN | 1.360000e+08 | 1.450000e+07 | NaN | 9000000.0 | NaN | 2.350000e+07 | CASADO | MASCULINO | CALI | 82.273973 |
| 9 | 1 | 404 | previhogar | previhogar | 99999 | NaN | NaN | 99999 | 1001837 | 01-2018 | 0 | 2.0 | NaN | NaN | NaN | 2.361596e+09 | 2.776884e+09 | NaN | NaN | NaN | 1.853277e+09 | OTRO | MASCULINO | CALI | 63.600000 |
Last rows
| CodigoTipoAsegurado__c | PuntoVenta__c | tipo_ramo_name | tipo_prod_desc | ClaseVehiculo__c | MarcaVehiculo__c | MdeloVehiculo__c | TipoVehiculo__c | NumeroPoliza__c | FechaInicioVigencia__ctrim | churn | n_prod_prev | total_siniestros | total_pagado_smmlv | anios_ultimo_siniestro | Activos__c | AnnualRevenue | MontoAnual__c | OtrosIngresos__c | Profesion__pc | EgresosAnuales__c | EstadoCivil__pc | Genero__pc | ciudad_name | edad | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 37699 | 1 | 3301 | responsabilidad civil | profesionales medicos | 99999 | NaN | NaN | 99999 | 1003693 | 02-2021 | 1 | NaN | NaN | NaN | NaN | 324578000.0 | 83160000.0 | NaN | 0.0 | NaN | 1.0 | OTRO | MASCULINO | otras | 61.054795 |
| 37700 | 1 | 3301 | responsabilidad civil | directores y administradores | 99999 | NaN | NaN | 99999 | 1027597 | 02-2021 | 1 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 37701 | 1 | 1048 | responsabilidad civil | directores y administradores | 99999 | NaN | NaN | 99999 | 1020099 | 02-2021 | 1 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 37702 | 1 | 1048 | responsabilidad civil | directores y administradores | 99999 | NaN | NaN | 99999 | 1023555 | 02-2021 | 1 | NaN | 2.0 | 1.415121 | 0.394521 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 37703 | 1 | 3301 | responsabilidad civil | profesionales medicos | 99999 | NaN | NaN | 99999 | 1027400 | 02-2021 | 1 | NaN | NaN | NaN | NaN | 18000000.0 | 60000000.0 | NaN | 0.0 | NaN | 58000000.0 | CASADO | MASCULINO | BOGOTÁ D.C. | NaN |
| 37704 | 1 | 3301 | responsabilidad civil | directores y administradores | 99999 | NaN | NaN | 99999 | 1027403 | 02-2021 | 1 | 14.0 | 704.0 | 5779.809377 | 0.060274 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 37705 | 3 | 3202 | responsabilidad civil | profesionales medicos | 99999 | NaN | NaN | 99999 | 1060113 | 02-2021 | 1 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 37706 | 1 | 8001 | responsabilidad civil | profesionales medicos | 99999 | NaN | NaN | 99999 | 1027255 | 02-2021 | 1 | NaN | NaN | NaN | NaN | 500000000.0 | 90000000.0 | NaN | 0.0 | NaN | 65000000.0 | SOLTERO | MASCULINO | BOGOTÁ D.C. | 122.515068 |
| 37707 | 1 | 8001 | responsabilidad civil | directores y administradores | 99999 | NaN | NaN | 99999 | 1027331 | 02-2021 | 0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 37708 | 1 | 8001 | responsabilidad civil | directores y administradores | 99999 | NaN | NaN | 99999 | 1027428 | 02-2021 | 1 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |